﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Admin_rizhi : System.Web.UI.Page
{
    DataClassesDataContext db = new DataClassesDataContext();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            var resultrizhi = (from p in db.rizhi
                               where p.userName.ToString().Contains(TextBox1.Text) || p.caozuo.ToString().Contains(TextBox1.Text)
                               orderby p.time descending
                              select p).ToList();
            GridView2.DataSource = resultrizhi;
            GridView2.DataBind();

        }
    }
    protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lbl = (Label)e.Row.Cells[0].FindControl("Label3");
            lbl.Text = (GridView2.PageIndex * GridView2.PageSize + e.Row.RowIndex + 1).ToString();
        }
    }
    protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        // 得到该控件
        GridView theGrid = sender as GridView;
        int newPageIndex = 0;
        if (e.NewPageIndex == -3)
        {
            //点击了Go按钮
            TextBox txtNewPageIndex = null;

            //GridView较DataGrid提供了更多的API，获取分页块可以使用BottomPagerRow 或者TopPagerRow，当然还增加了HeaderRow和FooterRow
            GridViewRow pagerRow = theGrid.BottomPagerRow;

            if (pagerRow != null)
            {
                //得到text控件
                txtNewPageIndex = pagerRow.FindControl("txtNewPageIndex") as TextBox;
            }
            if (txtNewPageIndex != null)
            {
                //得到索引
                newPageIndex = int.Parse(txtNewPageIndex.Text) - 1;
            }
        }
        else
        {
            //点击了其他的按钮
            newPageIndex = e.NewPageIndex;
        }
        //防止新索引溢出
        newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
        newPageIndex = newPageIndex >= theGrid.PageCount ? theGrid.PageCount - 1 : newPageIndex;

        //得到新的值
        theGrid.PageIndex = newPageIndex;
        var resultrizhi = (from p in db.rizhi
                           where p.userName.ToString().Contains(TextBox1.Text) || p.caozuo.ToString().Contains(TextBox1.Text)
                           orderby p.time descending
                           select p).ToList();
        GridView2.DataSource = resultrizhi;
        GridView2.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        var resultrizhi = (from p in db.rizhi
                           where p.userName.ToString().Contains(TextBox1.Text) || p.caozuo.ToString().Contains(TextBox1.Text)
                           orderby p.time descending
                           select p).ToList();
        GridView2.DataSource = resultrizhi;
        GridView2.DataBind();
    }
}